USE [ADVENTUREWORKS.CINEMA]

if not exists (select * from master.dbo.syslogins where loginname = N'alice')
BEGIN
	exec sp_addlogin 'alice' ,'alice', 'ADVENTUREWORKS.CINEMA'
END

exec sp_grantdbaccess 'alice'

exec sp_addrolemember 'db_owner', 'alice'